Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How could i enable insert picture from VBA?
Hello Friends,
I´m trying to insert a logo to a Excel file from VBA in a protecte worksheet. Could you give a hand to allow the user change the logo i he needs it? Thanks in advance, Jose Lui -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How could i enable insert picture from VBA?
Sub InsertPicture()
Activesheet.UnProtect Password:="ABCD" ' code to insert picture and position it Activesheet.Protect Password:="ABCD" End Sub -- Regards, Tom Ogilvy "jose luis " wrote in message ... Hello Friends, I´m trying to insert a logo to a Excel file from VBA in a protected worksheet. Could you give a hand to allow the user change the logo if he needs it? Thanks in advance, Jose Luis --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How could i enable insert picture from VBA?
Thank you Tom for your prompt response (as always!!).
Let explain my problem in a better way. I have a sheet that i protected, has some stuff that needs to be untouchable by the user, bu i would like to allow her/him to be able to change some text and a Logo The solution already given (thanks again) unprotects the entire sheet Is there a instruction that let me just give her/him the opportunity t enable the Insert/Picture/from file command, without giving her/him th chance to play around? Best Regards Jose Lui -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How could i enable insert picture from VBA?
I don't think so, but what I was suggesting was that you provide the
interaction with the user. Get their selection from getopenfilename for example. Then, unprotect, import and position the image, reprotect, i.e. the code never quits to allow the user access to the sheet. So your exposure would be minimal. You may be able to use finer granularity in xl2002 or xl2003 ( I don't have a copy handy/installed) but they offered much richer levels of protection. But I doubt they leave the menus enabled - could be wrong however. -- Regards, Tom Ogilvy "jose luis " wrote in message ... Thank you Tom for your prompt response (as always!!). Let explain my problem in a better way. I have a sheet that is protected, has some stuff that needs to be untouchable by the user, but i would like to allow her/him to be able to change some text and a Logo. The solution already given (thanks again) unprotects the entire sheet. Is there a instruction that let me just give her/him the opportunity to enable the Insert/Picture/from file command, without giving her/him the chance to play around? Best Regards Jose Luis --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
insert a picture in to a comment but picture not save on hard disk | Excel Discussion (Misc queries) | |||
How do I enable 'insert copied cells' (option not available in men | Excel Discussion (Misc queries) | |||
How do I enable insert copied cells (option not available in menu. | Excel Discussion (Misc queries) | |||
insert picture | Excel Discussion (Misc queries) |