| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allowing only one or two viewings of a worksheet?
I have made a macro that only allows a viewer to view a worksheet I've sent them once or twice, but I need to send it to someone who cannot run macros. Is there a non-vb way to only allow a person to view a worksheet once or twice (to clarify I want to send a sample sheet that will not be passed around).
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Allowing only one or two viewings of a worksheet?
Nope - not without some form of programming
The best way is to use a simple event macro behind the sheet that counts the number of times the sheet is opened - and when a set number is reached - it hides the sheet (idealy using xlveryhidden so the user cannot unhide it This is simple to write and does not require any interaction from the user |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| allowing sort in protected worksheet | Excel Discussion (Misc queries) | |||
| Allowing row deletion in worksheet with locked cells | Excel Discussion (Misc queries) | |||
| Allowing insert pictures in a protected worksheet | Excel Discussion (Misc queries) | |||
| How do I lock a worksheet while allowing users to add comments? | Excel Discussion (Misc queries) | |||
| Not allowing an Excel Worksheet to be opened in Word | Excel Programming | |||
Linear Mode
