I want to write a name in the cells and rename the TABS of Sheets 2-5. If no Name (i.e. in C6 then I want the Sheet 5 to be hidden).
Please see attached file to see what I mean.
Thank you a lot!
Re: Drag & Paste
Please find an example
I am trying to drag two cells (Column F & G) that have links to another worksheet to columns H & J (leaving the I column outside). I need to do that for several columns for the continuing columns. Do you have any tip?
Re: Use Group/Ugroup in Protected SheetsQuote from Dave Hawley
Right click on the sheet name tab, select View Code and in here paste the code below. Change the pasword to the one you use. If no password, remove: "Password:="Secret","
thanks for your help. I paste the code,save it and run it but then it appears a box asking for a Macros name.
can you help on it pls?
I would like to have other users who can view a protected worksheet be able to use the group/ungroup buttons to view or not view the lines that have been grouped. I have not been able to get the group/ungroup button to work when the worksheet is protected. Do you have tip? I saw some old tips but without any luck!
I've made a Word document and placed some check boxes in it.
I've exited design mode and saved the file, however every time I open it design mode is active. When I decrease the security level of macro to low then its fine but I need to send this to other people, without having ask them to do same.
Any clues on what I can do?
Re: Control Design Mode
AJW, have you find any solution for your problem (reopening word), I am facing the same!
asking again for help because my previous request was not understandable. I need to fix a button in excel (in the worksheet) and when I push it, I want a cell comment to open (insert) in the (different everytime) selected cell. This, I am guessing will need some makros.
Thank you a lot.
Dear all, I need some help.
I want to create a macro which will Insert Comment in every cell which I have choose.
Also I need another macro which will insert a whole line below the cell I have choose.
Thanks a lot
Let's say that I have 2 cells with amounts and a cell where i calculate their difference! I want when their difference is not between (for example) -1 and 1 , not to be able to save the file. Another function could be before saving an alarm box to be showed.
Thanks anyone who can help me!
Re: Lists(months) - hide/ UNhide columns
thanks for the help! It is almost want i wanted!Can you please explain me how i will transfer the whole codes, forms buttons to another workbook? Because i have copy - paste the tool box in another file and when I am opening it, also your file is needed to be opend (automatically). Can you also expain how I can change the type of tool-box (for example to have just a List Box with an arrow, pressing the arrow showing the months and then pick the month etc).
Thanks a lot again in advance for your help!
All the best
Dear all, iwould like some help!
I want to have a list of all the months in a sheet and when i will choose a month to hide and unhide columns in another sheet in the same workbook! Meaning that f.e. i choose march in the list and automatically i want to be transferred to another sheet where all the the completed cells are hidden and show me the columnes C,D H, and K (for example). I believe that is needed the use of VBA probably!
Thank you in advance for any help!