not very bright dave
Board Regular
- Joined
- Dec 20, 2004
- Messages
- 244
Hi
Is there a way, irrespective of which page the workbook may have been saved on, that on opening the workbook, the same front sheet can be the only one visble each time? Basically, I have a front access sheet which explains th workbook. I'm guessing ot might be something like:
on saving, open front sheet and hide current sheet
but I'm not sure what the code for this would be.
Thanks in advance
PS is there an easy way to password protect macros in a workbook?
Is there a way, irrespective of which page the workbook may have been saved on, that on opening the workbook, the same front sheet can be the only one visble each time? Basically, I have a front access sheet which explains th workbook. I'm guessing ot might be something like:
on saving, open front sheet and hide current sheet
but I'm not sure what the code for this would be.
Thanks in advance
PS is there an easy way to password protect macros in a workbook?