ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Allowing only one or two viewings of a worksheet? (https://www.excelbanter.com/excel-programming/294520-allowing-only-one-two-viewings-worksheet.html)

ryan

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).

Grey Newt

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