Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default List all sheets in the work book and select by double click

A good idea.
I already know how to make templates :-)

Kaj Pedersen


"Rick Rothstein" skrev i en meddelelse
...
I am glad that you introduced me to UserForms and I must say
that your instructions were very understandable and easy to follow.
I succeeded in setting it all up, so that I can call the window showing
all my sheets.
I think this is the method I prefer to implement.
Thanks again.


You are quite welcome. If you think you will want to use this idea on
other projects, you may want to do what I did... install the code on a
clean workbook (or just take the one you have and delete all data and any
VB code (other than the code I gave you of course) and then save the
workbook as an Excel Template. That way, whenever you start a new
workbook, just pick that template instead of a blank workbook and the
functionality will be immediately available. If this is a new concept to
you, write back with your Excel version number and I'll try to provide
instructions to you for that version.

Rick Rothstein (MVP - Excel)



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula in Excel does not work until after I double-click inside c raaaabert Excel Discussion (Misc queries) 7 June 8th 17 02:01 PM
Mouse double-click to select listbox item and run userform Lemi Excel Programming 3 July 19th 09 03:01 PM
Function does not work unless I double click the cell and push ent just me Excel Discussion (Misc queries) 4 March 14th 07 06:32 PM
Double click xlsname in explorer doesn't work. Lew Schwartz New Users to Excel 2 October 11th 06 02:33 PM
Double Click for all Sheets Marvin Excel Programming 4 March 17th 05 03:49 PM


All times are GMT +1. The time now is 05:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"