gudii9
asked on
excel save option
excel document every time i open asking to save changes even though i have not made changes? how to avoid this message prompt every time(even i made no changes) which i have to click no button
please advise
please advise
Please attach your workbook.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
EXPERT CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
To stop it from happening add this code in the ThisWorkbook module (and save the workbook).
how to go to that module. can you please put some steps, screenshots
- In Excel, Press Alt+F11 to open the Visual Basic Editor (VBE)
- In the "Project-VBAProject" pane, double-click 'ThisWorkbook
- Copy the code I posted above and paste it into the new window
- Save the workbook as an xlsm file,
And here is a macro you can use to turn automatic calculations back on.
Sub AutomaticCalc()
Application.Calculation = xlCalculationAutomatic
End Sub
- In Excel, Press Alt+F11 to open the Visual Basic Editor (VBE)
- Right-click on your workbook name in the "Project-VBAProject" pane. If you don’t see an existing module then select Insert -> Module from the menu bar. Otherwise just select the module.
- Copy the macro and paste it into the right-hand pane of the VBA editor ("Module1" window)
- Press Alt+F11 again to go back to Excel
- Optionally, press Alt+F8 to open the "Macro" dialog window. Select the macro, click ‘Options…’, hold down the Shift key and type the letter A (or any other letter) and click ‘OK’. Then anytime you want to run the macro press Ctrl+Shift+A.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you need screenshots I'm happy to provide them.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think this would be better solved if you attached your file if possible.