Geek Answers Handbook

EXCEL VBA UserInterfaceOnly: = True does not work

When I use (some code here).copy destination:=(some code there) . He will continue to request protection issues on cells . Basically, it just won't let my code work.

0
vba excel
source share
1 answer

The status of UserInterfaceOnly:=TRUE , unfortunately, is not saved in the file, so if you open the file again, it will be completely protected. Either use the Workbook_Open event to reapply this protection status, or cancel protection, and then immediately reprogram the worksheet in your VBA code.

See Ozgrid for more details!

+8
source share

More articles:


All Articles