LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VBA code for inactivating button

Hi I want to know if somebdy can help me VBA code for inactivating a
button if the value of a particular cell say C1 is blank.

Example: On Sheet1 have a button "knowledge" and on clicking this
button a sheet2 opens which have two buttons K1 and K2. I want if value
of a particular cell say C1 (on Sheet1) is blank then K1 should become
inactive or is disabled, otherwise it should be active. Similarly if
cell C2 (on Sheet1) is a blank the button (K2 on Sheet2)) should be
should be inactive else it should be active.

Hope i have made my question clear.

Regards
Raj

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to assign same code inside Option button code space ?? furbiuzzu Excel Programming 1 November 21st 06 02:36 PM
Inactivating of "Paste special" while linking charts klodvig Charts and Charting in Excel 0 September 11th 06 10:44 AM
Inactivating a Sub Function Premanand Excel Programming 5 May 7th 06 04:43 PM
Hit a button with VBA code [email protected] Excel Programming 2 March 6th 06 02:32 PM
How to make a button VBA code reference other VBA code subroutines??? gunman[_9_] Excel Programming 4 September 27th 05 01:01 AM


All times are GMT +1. The time now is 08:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"