• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Floating Worksheet

C

Cammandk

Member
I have a custom cost manager workbook with hidden sheets and vba code.

On my main entry sheet "CostManager" I want to be able to call up (probably via keystroke) a mini sheet to float that the user can use as a scrap working area - only needs to be say 10 x 10. It should save when closed

The Cost Manager sheet is protected with allowable user entry cells.


i can see how I could have a hidden sheet that I select via a keystroke macro - I dont know how to have it float on top of the active window?


david
 
This is non-trivial. You would probably have to use a userform. This requires quite extensive VBA coding, and it would only really be a series of text boxes stitched together to look like cells. So wouldn't be anything but a holding place for data, and I'm not sure if users would be able to cut and paste blocks of cells into it or not.
 
You must log in or register to reply here.
Back
Top