hide macros

[sufianmalik]

i've created several small macros and using 'call' run them together

is it possible to hide the smaller ones - from the Alt + F8 window etc)

 

[VoG]

Make them private:

Private Macro1()

 

[sufianmalik]

great thanks, what shall i do with lines: like application.screenupdating as it seems to be affected?

 

[VoG]

It shouldn't have any effect. What I should have written was

Private Sub Macro1()

 

[sufianmalik]

ah that could be it, i'll try again - thanks

 

[sufianmalik]

i get a compile error now when i call the first macro which is now private sub....

 

[VoG]

What compile error. Can you post your code using code tags

[code]
your code
[/code]