.onkey

  1. D

    Mutli Use Form

    I combined three forms into a mutli use form and would like help in figuring out how to modify current code to work. I would like to be able to change tab order and shade areas of form I don't need for curtain task based on wihcih command button used on menu page. Here is my current code.( some...
  2. M

    VBA Code - Effecting entire Workbook not just a Worksheet

    So yeah, I'm incredibly new to the code world. I found some VBA Code on this sit for changing the tab order and it worked great! Except that tab order started working on all 6 of the worksheets instead of just the one I had intended. Which is annoying. I think it should be a simple fix. Just...
  3. T

    How can I change this Code from being just Column G to Columns G:M

    Hi Everyone, The code below works great, but I'd like to expand its target from Column G to Columns G:M any ideas the best way to do this? Thanks Tony Private Sub Worksheet_SelectionChange(ByVal Target As Range) LastR = Sheets("Weekly Data Input").Cells(Rows.Count, "F").End(xlUp).Row...
  4. T

    How can I edit this to work on more than just one Cell?

    Hi Everyone, The code below is a stop for a protected sheet so the tabing doesn't go everywhere, however it only works on column G, how can I change it so it works on G:M? thanks Tony Private Sub Worksheet_SelectionChange(ByVal Target As Range) LastR = Sheets("Weekly Data...
  5. X

    Help with .OnKey in MAC (Command Key)

    Hi, I am using a code from this thread to prevent Cut,Copy,Paste on a certain range of a Sheet in workbook (Excel MAC): https://www.mrexcel.com/forum/excel-questions/696084-restrict-copy-paste-only-certain-cells-worksheet.html Which is working fantastic, except one thing that i am not able to...
  6. D

    Modify existing code that disables the delete and backspace key

    Hi, Please can someone help me? I have found the following code that disables the delete and backspace keys to all my sheets apart from the last sheet. I was wondering if anyone knows how to modify it so it only works on sheet3 or better still limiting it to the range of D40:BM40 on sheet3...
  7. C

    Protecting conditional formating but allowing comments

    Hi Guys ruiqure some assistance I have a spread sheet where multpile users input data on, but with this, they started copy/cutting and pasting breaking the complexes conditional formatting structure:banghead: I managed to get the cells, where they should not enter data, locked. Then managed...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top