Help to clarify the macro

K0st4din

Well-known Member
Joined
Feb 8, 2012
Messages
501
Office Version
  1. 2016
  2. 2013
  3. 2011
  4. 2010
  5. 2007
Platform
  1. 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
Code:
[B]DeleteSetting "Demo", "Demo", "Demo", 0[/B]
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
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top