block

Hello people I have a workbook with some sheets. The user can acess some sheets, but other sheets are "secret". There's no buttons to acess these sheets, but if the user uses the shortcuts CTRL+PGDOWN or CTRL+PGUP is possible. I want to block the acess to some sheets. How could I do that?

I want to be able to block a cell to prevent users from accessing it when displays all options but "mm". When it displays "mm" I want users to be able to access the cell. Here's the VBA code I have currently written (however I keep receiving error messages when trying to run it): Sub...

Greetings all, Is it possible to set conditions on a cell that would make it unusable (blocked out from editing, filled in black?) If A2 is $500,000 or more: B2 populates with "YES" If A2 is under $500,000: B2 is disabled from edits, filled in black Wasn't sure whether this was possible...

The code accomlishes its purpose. But, the OBJXL (excel object) is orphaned and refuses to be destryoed with Set ObjXL = Nothing Any suggestions would be welcome Without the OBJXL qualifier in front of .Range - it is an error. With the qualifier: <OBJEVCT Set Not Variable Block With or>...

I've got a variety of worksheets that are quite large and have formulas that have been copied down and across. The formulas use relative and absolute references, so some of the cell references change; whereas, others do not. As others work on my files (or I make an error), sometimes a formula...

I have this VBA code to copy and paste from cell K10 to C13-22 and it works okay but when it gets to 22 it comes up with a runtime error 91 - object variable or With Block variable not set. I assume this is because it does not know what to do when it gets to 22. I wondered if you knew a way of...

i copy paste several numbers and i need to use them in a forumlas. I cant add any currency and i can't use it in a formulas, the numbers seemed blocked; how can i fix it

Is there any way to block editing cells or columns for certain users? Let's say i want: John to edit column A Peter to edit Column B Peter and John column C. Is this possible? I don't know the information they are entering, so i can't restrict the content, but want to restrict the lines they...

Hello, I have 2 columns generated by a database. Address & Postcode. The address column is comma deliminated. I want to use this column in as the mail merge address but need to get each bit between commas on in a seperate cell. Looked at other posting on this site and I think i'm too...