View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rick S. Rick S. is offline
external usenet poster
 
Posts: 213
Default 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