Place shape/clipart over radio button

D

dgold82

I am developing an excel application but would like to create a "trial"
version as well. I was planning on placing transparent shapes over certain
areas of the application that would be deleted per a macro after my user
would put in a password. I figured out how to attach a password to a macro
and would record a simple macro that would remove the shapes but I can't
figure out how to get the shape (or even a clipart or picture) over the radio
buttons. No matter how many times I click on bring forward the radio buttons
are still on top.

How do I place an object over a radio button so that a user cannot click
them? I thought it would be much simpler.

Thanks.
 
S

smartin

dgold82 said:
I am developing an excel application but would like to create a "trial"
version as well. I was planning on placing transparent shapes over certain
areas of the application that would be deleted per a macro after my user
would put in a password. I figured out how to attach a password to a macro
and would record a simple macro that would remove the shapes but I can't
figure out how to get the shape (or even a clipart or picture) over the radio
buttons. No matter how many times I click on bring forward the radio buttons
are still on top.

How do I place an object over a radio button so that a user cannot click
them? I thought it would be much simpler.

Thanks.

Perhaps instead you could disable the radio buttons in code, or divert
the click event for unregistered users to give a notice. But be aware,
all of this is smoke and mirrors--"protected" Excel applications are not
too difficult to hack.
 
D

dgold82

Very true smartin. I found a small application called lockxls that will help
a bit with the protection. How would I go about disabling radio buttons on
certain worksheets? I wouldn't want to mess around with all the pointing and
cell connections that go along with them too much.

I actually just discovered a workaround. If you insert a bitmap object it
covers the radio buttons. I can just take a snapshot of the worksheet, place
a watermark (with "registered version only"), and put it over the radio
buttons. My macro then simply asks for a password and if correct deletes the
bitmap objects throughout the workbook.

Sometimes it helps just asking the question to think of weird solutions.
Thanks again.
 
S

smartin

Well kudos for that workaround. I apologize too, I was thinking of how
easy it is to disable /VB/ controls, but it is apparent you might be
using /form/ controls. They are two distinct animals, and I do not know
how to manipulate the latter in code.

Good luck with your application!
 

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

Top