ANmarS - Search results

Excel/VBA expert since Sep 1997 (19 years 6 months)

2 Blog posts found in October


Wed
Oct 26
2016

Frequent quick copy or Move



To copy quick to a certain location without jumping to copy and paste I usually get files in certain location, and most of the time want to move/copy them into same destination location A quick way to do that, is creating shortcut to that destination folder inside the source folder. Then when I want to copy/move a file, I just drag that file from the source folder (with CTRL to force copy, with Shift to force move) into the shortcut And it will be moved/copied as I intended to :-) Read more >>>

Wednesday Oct, 26, 2016 8:23
Tue
Oct 25
2016

Easiest way to unprotect Workbook or Worksheet without password


Looks like there is a bug in new Excel dealing with old Excel files
Tried that several times and it worked every time, it did actually remove the password for protected view of Worksheet and Workbook, it did not remove the protection, just the password.

So, If you have xlsx or xlsm with Workbook view or Worksheet view protected, do the following:

  • Save it as xls
  • Save it back as xlsx or xlsm
  • Now try to unprotect workbook or worksheet
Read more >>>

Tuesday Oct, 25, 2016 8:40