+ Reply to Thread
Results 1 to 9 of 9

Fixed the picture so can't be edit by user but not as background

  1. #1
    Registered User
    Join Date
    02-28-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    36

    Fixed the picture so can't be edit by user but not as background

    Hi,

    As the title say.

    I'm actually making a cover page for my excel where user have to click enter to proceed. Is there any other way to fix the logo so that when the user accidentally press on it, it wont go out of the place i put it in? As i dont know how to.

    Is it okay also to have a cover page that wont show the other spreadsheet that i link them together?

    Sorry, I can't find any thread in this forum that say on that. >< And have been trying since yesterday ><
    Last edited by Grace14; 03-01-2012 at 04:21 AM.

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Fixed the picture so can't be edit by user but not as background

    Assign a password to the macro so if they accidently click on it they have the option to cancel or proceed.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  3. #3
    Registered User
    Join Date
    02-28-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Fixed the picture so can't be edit by user but not as background

    erm. i already assign password to my macro project. but the picture still can be move>< is there any way to make a macro so that the pic wont move? even they try to move or click on it?

  4. #4
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Fixed the picture so can't be edit by user but not as background

    erm.... If it is still moving then you obviously have not done correctly. Post the work with sensitive info taken out.

  5. #5
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Fixed the picture so can't be edit by user but not as background

    Have you tried protecting the sheet and/or using an ActiveX image control?
    Good luck.

  6. #6
    Registered User
    Join Date
    02-28-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Fixed the picture so can't be edit by user but not as background

    No, I have try the ActiveX image control thing. what is it?

    Dummy.xlsm
    Last edited by Grace14; 03-01-2012 at 04:27 AM.

  7. #7
    Registered User
    Join Date
    02-28-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Fixed the picture so can't be edit by user but not as background

    Thank you so much
    Funny thing is i try that before and its not working

  8. #8
    Forum Expert OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,655

    Re: Fixed the picture so can't be edit by user but not as background

    Do you mean it's not working now, or didn't work before?

  9. #9
    Registered User
    Join Date
    02-28-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    36

    Re: Fixed the picture so can't be edit by user but not as background

    It didn't work before but it's working now

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1