26/07/2011 – SUBMEG

26/07/201121/12/2011

Excel VBA Tips: Selecting the Default Printer in VBA

Excel VBA Tips: Selecting the Default Printer in VBA I had created a document that is to be printed by multiple people in different locations. However, when pressing the print button that I created on the worksheet, I needed to ensure that the default printer for each location was selected. This can be done with…

26/07/201121/12/2011

Excel VBA tips: How to Run Macros When a Workbook or Worksheet is Protected

Excel VBA tips: How to Run Macros When a Workbook or Worksheet is Protected Have you created a workbook which contains macros, but you wish to protect the sheet? When you protect the sheet, it stops the macros from running, which is really annoying. However, there is a way around this. 1. Open up VBA…

M	T	W	T	F	S	S
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31