 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2008Qucik Access Toolbar help (Excel 2007)
I am not grasping some things about programming to the Quick Access Toolbar (QAT). I am trying to get a macro to show for any workbook that I open as long as it is opened from a specfic folder. Is this possible? Is there some sample code to look at? How much do I have to pay you to code it? ;)  SignatureRegards VBA.Newb.Confused XP Pro Office 2007 Hi Rick One simple way is to test the activeworkbook.path in the macro and only run the code if the files is opened from folder ??? See also the QAT examples in the 2007 section on my site for a few examples SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm >I am not grasping some things about programming to the Quick Access Toolbar > (QAT). [quoted text clipped - 3 lines] > Is there some sample code to look at? > How much do I have to pay you to code it? ;) Ron, milliseconds before your post I found how to check the path. I am also using your example from your website as a guide. For the list, does the hidden worksheet have to be in every workbook or can it be in my personal workbook? SignatureRegards VBA.Newb.Confused XP Pro Office 2007 > Hi Rick > [quoted text clipped - 10 lines] > > Is there some sample code to look at? > > How much do I have to pay you to code it? ;) Hi Rick Use a add-in See http://www.rondebruin.nl/2007addin.htm SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > Ron, milliseconds before your post I found how to check the path. I am also > using your example from your website as a guide. [quoted text clipped - 15 lines] >> > Is there some sample code to look at? >> > How much do I have to pay you to code it? ;) Thanks Ron! The Addin will work great! SignatureRegards VBA.Newb.Confused XP Pro Office 2007 > Hi Rick > [quoted text clipped - 22 lines] > >> > Is there some sample code to look at? > >> > How much do I have to pay you to code it? ;) One more question? How do I edit the Addin? I do not get to see the menu sheet anymore? SignatureRegards VBA.Newb.Confused XP Pro Office 2007 > Hi Rick > [quoted text clipped - 22 lines] > >> > Is there some sample code to look at? > >> > How much do I have to pay you to code it? ;) Alt F11 Select the Thisworkbook module of the add-in and in the properties change IsAddin to False. It is now a normal workbook Change the menu and set it back to true and save the add-in SignatureRegards Ron de Bruin http://www.rondebruin.nl/tips.htm > One more question? > How do I edit the Addin? I do not get to see the menu sheet anymore? [quoted text clipped - 25 lines] >> >> > Is there some sample code to look at? >> >> > How much do I have to pay you to code it? ;) Again, many thanks! SignatureRegards VBA.Newb.Confused XP Pro Office 2007 > Alt F11 > [quoted text clipped - 33 lines] > >> >> > Is there some sample code to look at? > >> >> > How much do I have to pay you to code it? ;) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.