Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: combine freeze pane and cell input message

  1. #1
    Guest

    Default

    I am trying to combine a freeze pains with the input message feature. To start, I would like to freeze the top of a page. This I can do (Window > Freeze Panes) and I want information to appear on certain cells on the top of the page when you click on them. This I can also do (Data > Validation > Input Message). But I canít get these to work in concert. When I freeze the panes the messages no longer appear in all of the cells above the freeze (They do still appear in the ones below it). Actually the drop down list does not appear either but it was not an issue in this particular case. How can I freeze the page and still have the messages appear? Any help would be greatly appreciated.

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    see if this helps, albeit negatively

    http://www.mrexcel.com/wwwboard/messages/22280.html


    :: Pharma Z - Family drugstore ::

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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