Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Qucik 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? ;) -- Regards VBA.Newb.Confused XP Pro Office 2007 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Qucik Access Toolbar help (Excel 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? ;) -- Regards VBA.Newb.Confused XP Pro Office 2007 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Access Toolbar help (Excel 2007)
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? -- Regards VBA.Newb.Confused XP Pro Office 2007 "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? ;) -- Regards VBA.Newb.Confused XP Pro Office 2007 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Access Toolbar help (Excel 2007)
Hi Rick
Use a add-in See http://www.rondebruin.nl/2007addin.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? -- Regards VBA.Newb.Confused XP Pro Office 2007 "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? ;) -- Regards VBA.Newb.Confused XP Pro Office 2007 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Access Toolbar help (Excel 2007)
Thanks Ron! The Addin will work great!
-- Regards VBA.Newb.Confused XP Pro Office 2007 "Ron de Bruin" wrote: Hi Rick Use a add-in See http://www.rondebruin.nl/2007addin.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? -- Regards VBA.Newb.Confused XP Pro Office 2007 "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? ;) -- Regards VBA.Newb.Confused XP Pro Office 2007 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Access Toolbar help (Excel 2007)
One more question?
How do I edit the Addin? I do not get to see the menu sheet anymore? -- Regards VBA.Newb.Confused XP Pro Office 2007 "Ron de Bruin" wrote: Hi Rick Use a add-in See http://www.rondebruin.nl/2007addin.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? -- Regards VBA.Newb.Confused XP Pro Office 2007 "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? ;) -- Regards VBA.Newb.Confused XP Pro Office 2007 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Access Toolbar help (Excel 2007)
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... One more question? How do I edit the Addin? I do not get to see the menu sheet anymore? -- Regards VBA.Newb.Confused XP Pro Office 2007 "Ron de Bruin" wrote: Hi Rick Use a add-in See http://www.rondebruin.nl/2007addin.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? -- Regards VBA.Newb.Confused XP Pro Office 2007 "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? ;) -- Regards VBA.Newb.Confused XP Pro Office 2007 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Access Toolbar help (Excel 2007)
Again, many thanks!
-- Regards VBA.Newb.Confused XP Pro Office 2007 "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... One more question? How do I edit the Addin? I do not get to see the menu sheet anymore? -- Regards VBA.Newb.Confused XP Pro Office 2007 "Ron de Bruin" wrote: Hi Rick Use a add-in See http://www.rondebruin.nl/2007addin.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? -- Regards VBA.Newb.Confused XP Pro Office 2007 "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rick S." wrote in message ... 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? ;) -- Regards VBA.Newb.Confused XP Pro Office 2007 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Quick Access Toolbar Resets each day | Excel Discussion (Misc queries) | |||
How do I hide the Quick Access Toolbar in Excel 2007? | Excel Discussion (Misc queries) | |||
Full screen apart from quick access toolbar Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Quick Access Toolbar Changes not Saved | Excel Discussion (Misc queries) | |||
Grouping of icons in the Quick Access Toolbar... Excel 2007 | Excel Discussion (Misc queries) |