Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 99
Default Place shape/clipart over radio button

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 915
Default Place shape/clipart over radio button

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.
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 99
Default Place shape/clipart over radio button

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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 915
Default Place shape/clipart over radio button

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.

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
Place text within clipart object softball player Excel Discussion (Misc queries) 1 January 20th 09 07:37 PM
radio button Chey Excel Discussion (Misc queries) 1 January 3rd 08 07:42 PM
Help with radio button Diana Excel Discussion (Misc queries) 1 July 17th 06 09:29 PM
How do I lock a radio button group if a N/A button is selected worry a lot Excel Discussion (Misc queries) 2 May 21st 05 08:33 PM
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True Mcasteel Excel Worksheet Functions 2 October 29th 04 07:06 PM


All times are GMT +1. The time now is 06:03 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"