Can anyone suggest a way to make the /x MacroName parameter work in a (Windows Vista Business 2006) shortcut (and preferably for different macros from different shortcuts)? It worked for me sometimes, but the more I tried to use the feature, the less it worked reliably and with full flexibility. (One can theoretically get the same workbook opened to different sheets by different shortcuts specifying different macro names. I have had the equivalent working in Access for years.)
I do get reliable operation if I use Auto_Open as a macro name, without having to specify it in a shortcut, but it can open the workbook only to one sheet and not to different ones on different occasions. (I use a modulo 2 counter on a sheet now that alternates which of 2 sheets it will open to.)
Thanks if you can help.
Roger Belling
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar