Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Prevent saving edited workbook

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    55
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a workbook with numerous formulas. The may at times overwrite the formulas with values. User will then print the worksheet. But I don't want it saved that way. The next time the workbook is opened I want the formulas to be there. The 'password to modify' isn't working the way I expect it to. I want to display a message if the user tries to save after making changes and prevent the save from taking place. Any suggestions?

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Save your workbook as a Template, using password to open. This will allow people to open a COPY of the workbook to use, but prevent them from overwriting the original.

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    55
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    My Excel workbook is an object, clled from a VB program. The password protected template doesn't seem to work in this case. It lets me save the template without a password. When I open the template by itself, it saves as an XLS with a "1" added to the end of the filename. But from VB it lets me save a revised XLT. Maybe I need to intercept the 'save' from within VB and display a message. Any ideas for the event (property, method?) to look for?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •