Run Time Error '1004' when displaying userform

[flipcube]

Hi all,

trying to display userform2 located in Book2.xlsm from a command button located in Book1.xlsm

here is my code:

Book2 code...

Sub Z()
userform 2.show
End sub

Book1 code...

Sub commandbutton1_click()
Application.Run "'Book2.xlsm'!Z"
end sub

both workbooks are open.

I get a Run Time Error '1004': Cannot run the macro "'Book2.xlsm'!Z". the macro may not be available in this workbook or all macros are disabled.

I've done some searching online and cannot understand why i am getting the error.

I'm wondering if it has something to do with the .xlsm extension

Thanks.

 

[flipcube]

Space between useform and 2 is a typo when I posted. it is not there in the actual VB code

 

[wigi]

For me it works perfectly in my test.

Is Book2.xlsm the correct name? Is that file saved?

 

[Norie]

Are both workbooks saved?

 

[flipcube]

Wigi, Norie,

yes, both files are saved and located in the same folder. I went home last night and tested it on Excel 2003 and it worked just fine. I tried it again this morning at work (Excel 2007) and it also worked.

I did not change anything from yesterday...operator error I guess.

Thanks

 

[wigi]

Okay, fine, thanks for confirmation.

 

[flipcube]

Hi all,

It seems that now I have the same issue as described above. I moved the respective workbooks from my H: drive onto one of my company's shared drives and now I am getting the same problem described above.

nothing has changed except the file locations. any ideas what could be causing the error now?

Thanks,
Flipcube

 

[Norie]

Are both workbooks open?

 

[flipcube]

Hi Norie,

Yes they are.

 

[taurean]

How are the macro enabling settings defined?

From your description, it seems as if in the macro settings:
Excel Options >> Trust Center >> Trust Center Settings >> Macro Settings
are different for Local Drives and Network Drives.
That is: Local Drives are added as Trusted Locations and Network Drives aren't.

So the workbook opened needs to be macro enabled before executing this code.