Search results

SirJB7, I am reluctant to upload the file as it contains 11 sheets and some personal information as well as various forms. I will create another file in which I can address these issues and will try that. I am busy this week but will get it out as soon as I can. Again, thank you for your...

Hi folks. This is the code I have in the ThisWorkbook module: Private Sub Workbook_Open() 'Define the sheet name and button name correctly With Worksheets("Equip. Issue").Shapes("CommandButton1") If Date >= DateValue("1/1/" & Year(Date)) And Date <=...

SirJB7, I have macros enabled and am using Excel 2007. Thanks for your assistance. KB

Narayan, I did this procedure and got a compile error "End with no IF". Where do I add the "IF" in order to clear this up? When I exited and re-started the sheet, the CommandButton vanished, but did not re-appear when I changed the date to the "visible" parameter. We're VERY close to a...

The code IS IN the ThisWorkbook module. Here is the code as I have it now: Private Sub Workbook_Open() 'Define the sheet name and button name correctly With Worksheets("Equip. Issue").Shapes("CommandButton1") If Date >= DateValue("1/1/" & Year(Date)) And Date <=...

Luke, Thanks for the quick reply. I copied and pasted the code in to the sheet after creating the CommandButton. Further, I followed your directions exactly by defining the sheet name and CommandButton name. However after saving, closing and re-opening, the CommandButton is still visible...

Hi folks. Keith here. I have a project for my Volunteer Fire Department in which I want to be able to update a membership roster between the dates of Jan 1 and Jan 15 each year. I would like to use an Option Button to activate a macro to acomplish this. I would also like the Option Button to...