Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: A macro (VBA) to group a number of worksheets

  1. #11
    Guest

    Default

    Many thanks Russell. This solved my problem.
    One further question, when I save this new workbook it saves references to the original workbook that I don't want saved. Since I have a lot of macro buttons on the work sheet it causes error messages if they are clicked. (When the workbook is reopened). Can I disable the ref to unsaved documents?

    Thanks
    John

  2. #12
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-13 16:58, Anonymous wrote:
    Many thanks Russell. This solved my problem.
    One further question, when I save this new workbook it saves references to the original workbook that I don't want saved. Since I have a lot of macro buttons on the work sheet it causes error messages if they are clicked. (When the workbook is reopened). Can I disable the ref to unsaved documents?

    Thanks
    John
    I guess I'd have to ask what kind of references you're talking about? Cell/formula references, or references in your code?

  3. #13
    Guest

    Default

    References are to macros.

  4. #14
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can you give an example? List the code if you can (all references)...

  5. #15
    Guest

    Default

    Thanks Russell

    I think I may be attacking this the hard way. It might be easier to assign a new macro to the buttons, although Iím not sure how to go about this.

    Iíll explain what I am doing. I have a workbook containing 33 worksheets and a very large amount of macro code. This workbook is about 1.4 mb.

    By making various entries and choices the user has a minimum of 3 and a maximum of 4 pages that they need to save. In order to reduce file size I am copying these pages to a new workbook (thanks to your code) and then saving this new workbook. The original workbook is not saved. The problem is that when the user opens the saved book if they click on any of the buttons they get a message saying (workbook1) macro not found. What I was trying to do was remove this reference, however in retrospect I think the better way would be to write a macro that would assign a new macro to the buttons. (a pop up message telling the user they were disabled).

    My problem here is that sometimes there will be 4 sheets and sometimes only 3. The sheet names will vary as will the number of buttons on each sheet. Another problem I am finding is that since I sometimes did a cut and paste of buttons often more than one is called button one (these were created from forms) so I could have say 3 button 1ís, 1 button 7 etc (incidentally can you rename these buttons).

    Is there a simple way to produce a macro that will select each sheet in turn, determine the number of buttons on that sheet then assign a new macro to them? I know any macro I write will be long and complicated compared with the simple code you provided for me to copy the sheets.

    Thanks for your time and help

    Regards John

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
  •