Micro Run after open excel file but do not show macro name.

[rr1050]

Dear All,

When I open excel file, I kept the Call command to run my particular macros.
These macros visible in Alt + F8

I do not they visible but they run when file Open.

Any idea , how to do it?

Reg, RL

[Kenneth Hobson]

I am not sure what you want. If you want to make them Private and not Public:

Please Login or Register  to view this content.

[rr1050]

Hi,

If I make Private then I cannot call the macro when workbook open!

Any other method!

[Kenneth Hobson]

Really? Did you put it in the ThisWorkbook's open event?

Another method is to make it a function.

[mc84excel]

Try this:

1. Open the macro workbook
2. Open the VBA Editor
3. Select the ThisWorkbook module (Go to Project Explorer, you'll find this under 'Microsoft Excel Objects')
4. Copy and paste the code below into ThisWorkbook module
5. Save and close the workbook
6. Reopen the workbook. The code should run. (If it doesn't then check that you enabled macros)

Please Login or Register  to view this content.

[Kenneth Hobson]

One other method to run a Private routine from another object is:

Please Login or Register  to view this content.

[rr1050]

I try by both method!
Both works perfect.

Again, I appreciate your time, effort and help.

Reg, RL