Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use of Command Buttons to Move Through Worksheets
Hi, everyone –
I was hoping that I could see if I could get some guidance on a somewhat strange problem I'm having in my rent calculation tool. The way I've got my tool set up is: [1] I've just replaced a number of hyperlinks to all of the tool's sheets with a series of command buttons on my Data Entry Sheet. The code for all of my new command buttons is tied to cell A1 of all of the other sheets; [2] Located in cell A1 of all of the other sheets (other than the Data Entry Sheet) include hyperlinks that "transport" the user back to the data Entry Sheet; [3] ALL of the sheets within the tool are protected. The problem that I'm having is that, when I use one of the new command buttons to move from the Data Entry Sheet to another sheet is that the PROTECTED SHEET message pops up as if I tried to access one of the protected cells. The thing is that it doesn't happen all the time --- that's the strange thing!!! I've tried unprotecting the sheet, unlocking cell A1, and reprotecting the sheet and then using the command button. What happens then is that the command button will move to the appropriate sheet but deletes the hyperlink in the sheet. Has anyone experienced this? Thanks, Golf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Buttons | Excel Discussion (Misc queries) | |||
command buttons disappear when I move worksheet 2007 | Excel Discussion (Misc queries) | |||
have toggle buttons but everytime print preview buttons move | Excel Discussion (Misc queries) | |||
Command Buttons | Excel Discussion (Misc queries) | |||
Control Buttons vs. Command Buttons | Excel Programming |