Saturday, April 17, 2010

Just past your name on single click

Here is the macro
Process is to use this is open your excel file click alt+F11 it will open one more window click on insert module & past this code in that module window. Replace your name with your own name
press save now close this window.
Sub yourname()
'
' yourname Macro
'
' Keyboard Shortcut: Ctrl+Shift+N
'
Application.WindowState = xlMinimized
Application.WindowState = xlNormal
ActiveCell.FormulaR1C1 = "yourname"
With Selection
.HorizontalAlignment = xlCenter
End With

ActiveCell.Offset(1, 0).Range("A1").Select
End Sub


Now just press Ctrl+Shift+N and see the magic.

Enjoy
Hemant

2 comments:

  1. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging

    Microsoft Excel Training in Electronic City

    ReplyDelete
  2. https://nelsonmstips.weebly.com/blog/how-licensed-microsoft-office-enhances-your-business-operations

    ReplyDelete

Hi Friends, After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day...