Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms
Good afternoon Eddie Right click on a toolbar and select customize. From the commands tab drag an icon (any icon) onto the toolbar you wan to add it to. Then right click your new icon, give it a name, give it a trendy imag (or draw your own) and assign your macro. Done. HTH Dominic -- dominic ----------------------------------------------------------------------- dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893 View this thread: http://www.excelforum.com/showthread.php?threadid=39951 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms
They problem is how do I call a Userform in a different workbook, but not
have that workbook open? Eddie "dominicb" wrote: Good afternoon Eddie Right click on a toolbar and select customize. From the commands tab drag an icon (any icon) onto the toolbar you want to add it to. Then right click your new icon, give it a name, give it a trendy image (or draw your own) and assign your macro. Done. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=399512 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms
You can't. The workbook needs to be open.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Eddie" wrote in message ... They problem is how do I call a Userform in a different workbook, but not have that workbook open? Eddie "dominicb" wrote: Good afternoon Eddie Right click on a toolbar and select customize. From the commands tab drag an icon (any icon) onto the toolbar you want to add it to. Then right click your new icon, give it a name, give it a trendy image (or draw your own) and assign your macro. Done. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=399512 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms
Could I hide the workbook?
"Chip Pearson" wrote: You can't. The workbook needs to be open. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Eddie" wrote in message ... They problem is how do I call a Userform in a different workbook, but not have that workbook open? Eddie "dominicb" wrote: Good afternoon Eddie Right click on a toolbar and select customize. From the commands tab drag an icon (any icon) onto the toolbar you want to add it to. Then right click your new icon, give it a name, give it a trendy image (or draw your own) and assign your macro. Done. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=399512 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userforms
Yes, the workbook could be hidden. Of course, the procedure that
shows the userform must be in the hidden workbook. You can't directly access a userform in another workbook, hidden or not. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Eddie" wrote in message ... Could I hide the workbook? "Chip Pearson" wrote: You can't. The workbook needs to be open. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Eddie" wrote in message ... They problem is how do I call a Userform in a different workbook, but not have that workbook open? Eddie "dominicb" wrote: Good afternoon Eddie Right click on a toolbar and select customize. From the commands tab drag an icon (any icon) onto the toolbar you want to add it to. Then right click your new icon, give it a name, give it a trendy image (or draw your own) and assign your macro. Done. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=399512 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Userforms | Excel Discussion (Misc queries) | |||
I need some help with userforms | Charts and Charting in Excel | |||
Userforms | Excel Programming | |||
Userforms..... | Excel Programming | |||
Userforms | Excel Programming |