running a macro when opening a work book

**madhatter40** · 06-23-2013, 03:15 PM

I have the following code and it isn't working for me. The first part is on the specific sheet. The second code is in a module called "Shift" When I run the code manually it works, just not when I open the workbook. Any help?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**TMS** · 06-23-2013, 03:34 PM

The first part should be in the Workbook module, not a worksheet module.

However, as far as I can see, you haven't selected a sheet or a range within a sheet so the effect could be fairly random.

Regards, TMS

**madhatter40** · 06-23-2013, 04:27 PM

When I open this workbook I get the following error:
Compile error:
Expected variable or procedure, not module
The error is in the following code:

Please Login or Register  to view this content.

I believe it's error is trying to call the "Shift" macro

**madhatter40** · 06-23-2013, 05:02 PM

So I think I figured it out. Here is the following code I inserted into "ThisWorkbook"
The yellow code is what I had to add in order to make it work.

Please Login or Register  to view this content.

**TMS** · 06-23-2013, 05:16 PM

That would make sense ... as I said, there was no indication of sheet or range selection.

Please note that a yellow font colour on a grey background is virtually unreadable.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.