![]() |
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).
|
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 |
All times are GMT +1. The time now is 07:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com