Excel shapes on worksheet 1









up vote
0
down vote

favorite












How do you find the name of a shape on a worksheet in developer mode?



I have a shape on a worksheet that is used as a watermark. When printing I want to hide it but when saving as a PDF I want to show it. I eventually found out that the shape was the second on the sheet and used the following code.



 Sheets("eCSD").Shapes(2).Visible = False
Sheets("eCSD").PrintOut
Sheets("eCSD").Shapes(2).Visible = True


Now save a PDF with the shape visible



Sheets("eCSD").ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=pdf_folder & "" & UCase(txtUCI.Text), _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False


What I would like to do is click on the shape in developer mode and see its properties, including its name. Is this possible? All I can get is the properties of the sheet, not the objects on it.










share|improve this question

























    up vote
    0
    down vote

    favorite












    How do you find the name of a shape on a worksheet in developer mode?



    I have a shape on a worksheet that is used as a watermark. When printing I want to hide it but when saving as a PDF I want to show it. I eventually found out that the shape was the second on the sheet and used the following code.



     Sheets("eCSD").Shapes(2).Visible = False
    Sheets("eCSD").PrintOut
    Sheets("eCSD").Shapes(2).Visible = True


    Now save a PDF with the shape visible



    Sheets("eCSD").ExportAsFixedFormat _
    Type:=xlTypePDF, _
    Filename:=pdf_folder & "" & UCase(txtUCI.Text), _
    Quality:=xlQualityStandard, _
    IncludeDocProperties:=True, _
    IgnorePrintAreas:=False, _
    OpenAfterPublish:=False


    What I would like to do is click on the shape in developer mode and see its properties, including its name. Is this possible? All I can get is the properties of the sheet, not the objects on it.










    share|improve this question























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      How do you find the name of a shape on a worksheet in developer mode?



      I have a shape on a worksheet that is used as a watermark. When printing I want to hide it but when saving as a PDF I want to show it. I eventually found out that the shape was the second on the sheet and used the following code.



       Sheets("eCSD").Shapes(2).Visible = False
      Sheets("eCSD").PrintOut
      Sheets("eCSD").Shapes(2).Visible = True


      Now save a PDF with the shape visible



      Sheets("eCSD").ExportAsFixedFormat _
      Type:=xlTypePDF, _
      Filename:=pdf_folder & "" & UCase(txtUCI.Text), _
      Quality:=xlQualityStandard, _
      IncludeDocProperties:=True, _
      IgnorePrintAreas:=False, _
      OpenAfterPublish:=False


      What I would like to do is click on the shape in developer mode and see its properties, including its name. Is this possible? All I can get is the properties of the sheet, not the objects on it.










      share|improve this question













      How do you find the name of a shape on a worksheet in developer mode?



      I have a shape on a worksheet that is used as a watermark. When printing I want to hide it but when saving as a PDF I want to show it. I eventually found out that the shape was the second on the sheet and used the following code.



       Sheets("eCSD").Shapes(2).Visible = False
      Sheets("eCSD").PrintOut
      Sheets("eCSD").Shapes(2).Visible = True


      Now save a PDF with the shape visible



      Sheets("eCSD").ExportAsFixedFormat _
      Type:=xlTypePDF, _
      Filename:=pdf_folder & "" & UCase(txtUCI.Text), _
      Quality:=xlQualityStandard, _
      IncludeDocProperties:=True, _
      IgnorePrintAreas:=False, _
      OpenAfterPublish:=False


      What I would like to do is click on the shape in developer mode and see its properties, including its name. Is this possible? All I can get is the properties of the sheet, not the objects on it.







      excel vba






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 12 at 0:06









      Malcolmf

      143




      143






















          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          If you click on the shape on the sheet where it appears, its name should appear in the name box (top left).






          share|improve this answer




















          • Thank you. Sometimes these things are just too easy..
            – Malcolmf
            Nov 12 at 10:22










          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53254490%2fexcel-shapes-on-worksheet-1%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          up vote
          0
          down vote













          If you click on the shape on the sheet where it appears, its name should appear in the name box (top left).






          share|improve this answer




















          • Thank you. Sometimes these things are just too easy..
            – Malcolmf
            Nov 12 at 10:22














          up vote
          0
          down vote













          If you click on the shape on the sheet where it appears, its name should appear in the name box (top left).






          share|improve this answer




















          • Thank you. Sometimes these things are just too easy..
            – Malcolmf
            Nov 12 at 10:22












          up vote
          0
          down vote










          up vote
          0
          down vote









          If you click on the shape on the sheet where it appears, its name should appear in the name box (top left).






          share|improve this answer












          If you click on the shape on the sheet where it appears, its name should appear in the name box (top left).







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 12 at 0:41









          kevin9999

          25146




          25146











          • Thank you. Sometimes these things are just too easy..
            – Malcolmf
            Nov 12 at 10:22
















          • Thank you. Sometimes these things are just too easy..
            – Malcolmf
            Nov 12 at 10:22















          Thank you. Sometimes these things are just too easy..
          – Malcolmf
          Nov 12 at 10:22




          Thank you. Sometimes these things are just too easy..
          – Malcolmf
          Nov 12 at 10:22

















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53254490%2fexcel-shapes-on-worksheet-1%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Top Tejano songwriter Luis Silva dead of heart attack at 64

          政党

          天津地下鉄3号線