Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Glasgow, Scotland
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Option Buttons revisited (97)

    Have now created my questonnaire but on testing the option buttons discovered that the copy and paste onto other sheets did not correctly maintain the cell link property link. Have attached the file which was given last time and all I have done is copy sheet 2 and made sheet 2 (2), the sheet 2 (2) doesn't allow you to make any updates. Also in some instances the cell link itself disappears when you save the file and then come back to it at a later stage, so that when the button is selected no cell updates as a result.
    Is there any way of forcing the buttons to remember the link?

    Sorry I hopefully have attached the sheet this time
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Winnipeg, Canada
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Option Buttons revisited (97)

    Not entirely sure what the problem is.
    The links on sheet 2 are missing, but sheet 2(2) works fine.
    After I fixed links on sheet 2 and copied the sheet to 2(3), sheet 2(3) also works fine.

    Saved the file and re-opened it, and everything is still working as I hoped.

    Are we on the same page? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  3. #3
    Lounger
    Join Date
    Feb 2001
    Location
    Glasgow, Scotland
    Posts
    46
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Option Buttons revisited (97)

    How are you creating the sheet 2(2). I have just tried to do what you performed. fixed the links in sheet 2, then used the copy sheet clicking the right button of the mouse and using the move /copy option. When I perform this the sheet 2 option buttons are cleared and the copied ones do not allow me to update. Is there some option that I have to set to allow the mechanism to work as you suggested.

    I attach my new listing
    Attached Files Attached Files

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Winnipeg, Canada
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Option Buttons revisited (97)

    <P ID="edit"><FONT SIZE=-1>Edited by WebGenii on 13-Jul-01 11:59.</FONT></P>I am sorry, but I am not able to help you any further. I cannot duplicate your problems and I can't find anything in Help. Read Move or Copy sheets.

    Try FreeAnswers.com also.
    <A target="_blank" HREF=http://www.freeanswers.com/default.asp>http://www.freeanswers.com/default.asp</A>

Posting Permissions

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