View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gustaf Gustaf is offline
external usenet poster
 
Posts: 69
Default Letting buttons depend on the sheet?

Gustaf wrote:
I'm using Excel 2007. I wonder if it's possible with VBA to have
different buttons appear for different sheets? That is, when I go from
one sheet to another, some buttons shall disappear and some shall
appear, so that only the set of buttons relevant to the active sheet is
visible. If this is not possible, are there other ways to achieve
something similar?


Just to clarify, I'm talking about toolbar buttons that activate custom VBA macros.

Gustaf