K0st4din
Well-known Member
- Joined
- Feb 8, 2012
- Messages
- 501
- Office Version
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hello, everyone,
I need a little explanation because I get confused or I do not know how to do it.
I found what I need as a macro, but on a page of the Microsoft, the final is somehow explained, at least difficult for me.
Here is the article:
https://www.microsoft.com/en-us/mic...mit-the-number-of-times-a-file-can-be-opened/
I'm not clear if the macros are locked in workbook, there's really no way to go in and change the opening time of the file itself.
Man says to do, a macro of this kind:
"To reset this to zero on your own machine, you can either run SaveSetting "Demo", "Demo", "Demo", 0, or you can run another variation of the VBA called DeleteSetting. This syntax is:
DeleteSetting "Demo", "Demo", "Demo", 0"
My first request is whether I correctly wrote
or is not it correct?
My second question is - To work, should I make this macro in another workbook?
Because if it is in the same workbook, after the specified number of openings, the workbook will close and there is no option to cancel.
Thank you in advance to everyone.
Greetings
I need a little explanation because I get confused or I do not know how to do it.
I found what I need as a macro, but on a page of the Microsoft, the final is somehow explained, at least difficult for me.
Here is the article:
https://www.microsoft.com/en-us/mic...mit-the-number-of-times-a-file-can-be-opened/
I'm not clear if the macros are locked in workbook, there's really no way to go in and change the opening time of the file itself.
Man says to do, a macro of this kind:
"To reset this to zero on your own machine, you can either run SaveSetting "Demo", "Demo", "Demo", 0, or you can run another variation of the VBA called DeleteSetting. This syntax is:
DeleteSetting "Demo", "Demo", "Demo", 0"
My first request is whether I correctly wrote
Code:
[B]DeleteSetting "Demo", "Demo", "Demo", 0[/B]
My second question is - To work, should I make this macro in another workbook?
Because if it is in the same workbook, after the specified number of openings, the workbook will close and there is no option to cancel.
Thank you in advance to everyone.
Greetings