Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Place text within clipart object | Excel Discussion (Misc queries) | |||
radio button | Excel Discussion (Misc queries) | |||
Help with radio button | Excel Discussion (Misc queries) | |||
How do I lock a radio button group if a N/A button is selected | Excel Discussion (Misc queries) | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |