Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Occassionally someone makes a mod to a document and forgets to clear the selections and set the view back to the first page, then saves it. Does anyone know how I can prevent selections being saved in documents and ensure the first page is always shown when the users enter the application?
Thanks!
You can use Events & Triggers to Unclear the selections....
Hi,
I don't know if it is easy to prevent to save it in the way you want, but you could clear everything and go to the right sheet using triggers:
Go to triggers (Settings ->document properties - > Triggers) and select the 'OnOpen' event.
There, include a clearAll and Layout -> Activate Sheet
Include the sheet ID (you can find the ID on the sheet properties)
Hi,
One solution could be, write a macro to clear all selections and activate your 1st sheet and map this function to "OnOpen" Trigger. So when ever the application is opened, Trigger would be fired and call the marco to clear the selection and activate the 1st sheet.
Your mode code should be something like below
Sub OnOPenDoc
ActiveDocument.ClearAll false
ActiveDocument.ActivateSheetByID "SH01"
End Sub
Hope this may helps you
- Sridhar