Macro | Lyte Byte

Tag Archive for 'macro'

How to Create Custom Keyboard Shortcuts in Excel 2007?

Published October 6, 2008 in How To, Software, Tips and Tutorial. 5 Comments

If you are new here, Subscribe to Full Feeds or by Email and receive free daily updates on Tips, Tricks and Tweaks..

Create custom keyboard shortcut in Excel 2007 using macros. Keyboard Shortcut in Excel to Paste special with transpose.

How to Unhide Personal.xlsb and Edit it in Excel 2007?

Published September 9, 2008 in How To, Operating System, Software, Tips and Tutorial. 3 Comments

How to unhide personal.xlsb personal macro workbook in Excel 2007 in vista and XP. Edit personal macros in VB editor. unhide hidden workbook in excel

What are A1 and R1C1 Reference Style in Excel?

Published April 29, 2008 in How To, Software, Tips and Tutorial. 2 Comments

What are A1 and R1C1 reference style in Excel and how to use it? Absolute and relative reference using R1C1 reference style. Tutorial and examples of R1C1 reference style and A1 reference style. Using R1C1 reference style in Excel Macros and Formulas

How to Insert Multiple Empty Rows or Columns in Excel?

Published March 27, 2008 in How To, Software and Tips. 5 Comments

How to Insert multiple rows or columns in MS excel 2007 using different methods. Using insert copied cells, keyboard shortcut to insert rows and excel VB macro…

Where are the Macro Features and Settings in Excel from Office 2007?

Published March 20, 2008 in How To, Software, Tips and Tutorial. 1 Comment

how to change macro features and settings in Excel and Office 2007? how to enable or show developer tab in office 2007? macros in excel 2007 and visual basic for application VBA