embedded chart vs chartsheet detection

  • Thread starter Thread starter George Burdell
  • Start date Start date
G

George Burdell

How can I tell if the user is on an embedded chart on a worksheet versus
being on a chart sheet when they run a macro?

Buffaloed....
 
You didn't say what you wanted to evaluate. I'll assume the Activesheet

Sub SheetType(
Select Case ActiveSheet.Typ
Case xlChar
MsgBox "ChartSheet
Case xlWorkshee
MsgBox "Worksheet
Case Els
MsgBox "Some rare sheet type, check out the xlSheetType enum.
End Selec
End Su
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using VBA to copy a Chartsheet to Powerpoint 2
Problem copying table data as a picture onto chartsheet 6
Dynamic chart problem 1
Problem exporting Chart as a jpg 4
Copying Charts: CODE NOT ROBUST 2
How to Handle Chart Sheets 2
Deleting All charts using VB 3
How to determine if a chart is embedded or not 7

Back
Top