Posts by ilpap75

  • Drag & Paste

    Dear all,
    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?
    Thank you

  • Use Group/Ugroup in Protected Sheets

    Re: Use Group/Ugroup in Protected Sheets


    Quote from Dave Hawley

    Hi Saint


    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","

    Code
    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    With Me
        .Protect Password:="Secret", UserInterFaceOnly:=True
        .EnableOutlining = True
    End With
End Sub


    Dear Dave,
    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?
    thank you

  • Use Group/Ugroup in Protected Sheets

    Dear All
    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!
    Thank you!

  • design mode exit

    Hi All,


    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?

  • Button for inserting comment

    Dear all,
    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.

  • Macro for adding cell comment

    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

  • If Conditions and Saving

    Dear all,
    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!

  • Lists(months) - hide/ UNhide columns

    Re: Lists(months) - hide/ UNhide columns


    Dear tinyjack,
    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

  • Lists(months) - hide/ UNhide columns

    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!