ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to look at objects in the form (https://www.excelbanter.com/excel-programming/330546-how-look-objects-form.html)

mtlpp

How to look at objects in the form
 

Hi all,

How to look at objects in the form?
it looks like the form was locked when I try to see the command button
and modify
something inside

Thanks in advance,


--
mtlpp
------------------------------------------------------------------------
mtlpp's Profile: http://www.excelforum.com/member.php...o&userid=23348
View this thread: http://www.excelforum.com/showthread...hreadid=375302


Tom Ogilvy

How to look at objects in the form
 
Assuming the worksheet isn't protected, (tools=Protections=Unprotect Sheet
isn't an option presented).

On the control toolbox toolbar, make sure the upper right button appears
depressed. This signifies you are in design mode. If you still can't edit
the properties, click on the control and click the next button to the right
on the control toolbox toolbar - this should be the properties button. (or
find the properties button on the toolbar and press it). This should give
you the properties window.

--
Regards,
Tom Ogilvy

"mtlpp" wrote in
message ...

Hi all,

How to look at objects in the form?
it looks like the form was locked when I try to see the command button
and modify
something inside

Thanks in advance,


--
mtlpp
------------------------------------------------------------------------
mtlpp's Profile:

http://www.excelforum.com/member.php...o&userid=23348
View this thread: http://www.excelforum.com/showthread...hreadid=375302




mtlpp[_2_]

How to look at objects in the form
 

Thanks Tom.
It works great.
mtlp

--
mtlp
-----------------------------------------------------------------------
mtlpp's Profile: http://www.excelforum.com/member.php...fo&userid=2334
View this thread: http://www.excelforum.com/showthread.php?threadid=37530



All times are GMT +1. The time now is 06:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com