In one of my lotusscript code, I output some data to excel. Initially I only allow the user to print and not make any changes to the spreadsheet. But then the user request that they want to resize the cell, adjust height etc before printing and that these changes can be saved. But I don't want them to change the data inside. Is that possible? If I set the whole excel file as read-only then the user won't be allowed to save any changes at all including the cell resizing.
Unlock the sheet and Throw this into the VBA and run it. It will do what you're looking for for the activesheet. Replace "Password" with your password.