View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default selecting workbook/worksheet from browse button

Tom is right, that is where the idea originates. My adaptation uses
optionbuttons and activates the selected sheet to specifically address
Monika's problem.

Normally do attribute, but I find it so useful, and am using it so much
recently, I often forget.

Bob

"Tom Ogilvy" wrote in message
...
Just for interest, if you want to see a commented version of the
BrowseSheets code (slightly different - uses check boxes and has added

code
to print out the selected sheets), you can look at John Walkenbach's site:

http://j-walk.com/ss/excel/tips/tip48.htm
Displaying a Menu of Worksheets to Print

Only if your are interested in how the code works.

--
Regards,
Tom Ogilvy