View Single Post
  #1   Report Post  
Merridas Merridas is offline
Junior Member
 
Posts: 2
Default Link to Previous vs Protected View

I have written a macro that creates a new section with new page and in that page it goes to the header and turns off "Link to Previous" (by default is "on") option and makes changes to the header in the new section. Works perfectly.

However I have a specially formated table on first page that has to be filled by other but not changed in any way. I employed to protect it from formatting a Protected View. This also works perfectly.

The problem I have is that when I turn on "Protected View" the option "Link to Previous" turns grey (not clickable) which means my macro crashes.

Any thoughts how to solve my problem?
- maybe a way to change default "Link to Previous" to "off" or
- a way to enable "Link to previous" checking/unchecking while in "Protected View" or
- some other option.

Thanks in advance.