I have the same problem

D

Daryl van Horn

Hi Mike,
I have exactly the same problem. Before SP2 everything worked fine. Have u figured out how to solve the problem? If you have, please let me know.

Thanks!
Daryl van Horn



Mike Clemens wrote:

Office SP2 - Problem with macro assigned to a button changing, Worked with SP1
06-maj-09

I installed Office SP2 and now have the following problem

I have a workbook that creates a new worksheet in the workbook using a macro.
The macro is executed by pressing a button (actually a shape with a macro
assigned to it) on the first worksheet in the workbook. At the end of the macro
that creates the new worksheet there is some code to move the new worksheet to a
new workbook. When the move occurs the macro assigned to the button and also 2
other buttons on the original worksheet are changed to point to the new workbook
created by the move operation

Here are the lines of code that cause the move and the macro button changes

sheets(RptWrkSht).mov

RptWrkSht is a string variable that holds the name of the worksheet that is
being moved

The problem started with the install of SP2. Anyone have any ideas on how to
stop the problem with the macro assignments changing

Thank

Mike Clemens

EggHeadCafe - Software Developer Portal of Choice
Build a .NET HTML Form Parser Application
http://www.eggheadcafe.com/tutorial...16-438f4d534375/build-a-net-html-form-pa.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top