Yes your logic is correct. Unless you store the macro in the actual
workbook, it doesn't get sent when you e-mail the file to someone so
they cannot open it. Conversely, I have saved macros that hide and
unhide certain worksheets within a workbook (confidential stuff, for
example) in my personal workbook. If you want to give access to
someone to unhide and rehide, you have to then physically copy the
macro to their own personal workbook (or, if they're not down the hall,
send them the code).


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=491639