Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,073
Default How to Place a Drawing Object on a Worksheet as a Control?

On Jan 21, 11:31 pm, SteveM wrote:
On Jan 20, 8:31 pm, Ken Johnson wrote:

Oops!
The last line should have been...
ActiveSheet.Shapes(Application.Caller).Visible = True


Ken Johnson


Ken,

That works! Thanks!

BTW, the Shape.Visible property options only presented msoFalse and
msoTrue when inputing the code which are new to me and apparently do
nothing in this simple case. But True and False do work like desired.

SteveM


Hi Steve,

You're welcome.
I don't know of any difference between msoTrue (or msoFalse) and True
(or False).

Ken Johnson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Erase Drawing Object smandula Excel Programming 3 October 15th 07 03:23 PM
Selecting Drawing Object By Name Zone Excel Programming 3 December 22nd 06 08:21 PM
Drawing Object in a Userform Zone Excel Programming 4 May 9th 06 08:27 PM
Drawing Object Shawn Excel Programming 2 March 2nd 05 03:04 PM
Drawing object references JASon Excel Programming 2 August 28th 03 10:49 PM


All times are GMT +1. The time now is 04:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"