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.

dgold82 wrote:
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.

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.

"smartin" wrote:

dgold82 wrote:
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.

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!

dgold82 wrote:
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.

"smartin" wrote:

dgold82 wrote:
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.