Calling subs

[fvmeul0]

I try to set up a ribbon to improve the user interface of my excel sheet. The code generated by the Custom UI editor is located in a 'Module'.

I want to call a sub located in the 'Workbook', from a Sub located in a 'Module', and get an error.

What is the right way to call a sub in this situation ?

'Callback for customButton1 onAction

Please Login or Register  to view this content.

with bigImport as the sub located in the Workbook.

Thanks,

François

[teylyn]

what do you mean by

call a sub located in the 'Workbook',

is that a sub in the ThisWorkbook module? If so, it can not be called by another procedure outside the ThisWorkbook module

In the Sheet and ThisWorkbook modules, it's best to use only the event subs. All other subs should go into a standard module. You can not call subs in the Sheets or ThisWorkbook module from any other module. But procedures in a standard module can be called from any other sub.

(as far as I'm aware)

cheers, teylyn

[fvmeul0]

Thanks, I just had to relocate all the subs from the worksheet to a module. Now it works fine.

Thanks a lot for this very fast answer.

François

[royUK]

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

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