I have a workbook with multiple sheets, the sheets will be labels 18.08.14 , 25.08.14 etc.
I have an activex Command button that will once pressed run code to send a section of the sheet as an email to a group of people. I need to disable this button when we're no longer in this period. i.e. if todays date is greater greater than 7 days from the sheet name either disable or hide the button.
Thank you for any advice or help, in advance.
Last edited by Kramxel; 08-26-2014 at 07:36 AM.
Hi Kramxel,
Try the attached workbook (tested using Excel 2003). Please note that I have had problems in the past moving ActiveX controls between Excel Versions. If the sample workbook doesn't work, please delete the Active X Buttons and replace them with new Active X 'CommandButton1' and 'CommandButton2' before giving up and thinking that the code doesn't work.
ThisWorkbook Code:
Sheet Code (on every sheet):
Please Login or Register to view this content.
Ordinary Module Code (e.g. Module1):Please Login or Register to view this content.
LewisPlease Login or Register to view this content.
Hi,
Thank you for this.
I think I've got it working, however for some reason Sheets(1).Select on the open workbook sub is throwing an error (run-time error 1004, application-defined or object-defined error), if i change it it sheets(2).select it works fine.
Last edited by Kramxel; 08-26-2014 at 08:57 AM. Reason: I was being an idiot.
It's a known feature (which I just discovered) that Excel occasionally behaves in the manner you described (Runtime Error 1004 for a select or activate) during 'Workbook_Open().
Try the attached file which implements the following changes:
ThisWorkbook Module:
Ordinary Code Module (the following was added):Please Login or Register to view this content.
LewisPlease Login or Register to view this content.
Bizarre this didn't solve the problem either exact same problem (but when I call the sheet by name works fine)
Thanks for the feedback. I'll make a note that the problem still exists for future reference.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks