Solved

Diable Command Button at the Time of Spreadsheet open and enable later using another command button

Posted on 2011-02-22
1
330 Views
Last Modified: 2012-05-11
I want to disable the CommandButton1 at the time of opening the excel sheet, and later enable using another commandbutton2 with a piece of VB code.

How could i acheive this
0
Comment
Question by:srikanthv2322
1 Comment
 
LVL 10

Accepted Solution

by:
shahzadbux earned 500 total points
ID: 34953477
Try out the attached sheet...
Book1.xlsm
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel Lookup - True if return at least one match 9 44
Frequency distribution of horizontal data? 5 29
copy same as above data 18 37
batch file or script 4 24
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question