Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Problem using Alt + F11 & with a worksheet

0

Excel Macro Class 1 - Getting Started Programming Macros

I watched the above video on youtube yesterday.  Then today I have a problem at work when I pressed Alt + F11.  I posted the following help message in the comments but then I noticed that nobody has posted any comments in over a year except for me.  So I am posting this here hopefully to get help from someone.  

"I watched your video for class 1 yesterday and can't wait to learn more.  But a problem has come to one of my Excel workbooks for work.  One of the worksheets in my Police Dept. Employee Workbook that I created previously called Mail Merge, is acting strange.  Today when I went to add a new officer, the cells that I would click on to type in didn't have the usual border highlighted with the grab bar at the bottom right corner.  I could still type in them but when I tried to highlight certain cells to copy, they didn't show up as highlighted.  I could still copy them though.

Then I thought I would go to check any code in the VBA window.  I pressed Alt +F11 and just like yesterday it took me to the VBA window.  But I saw no VBA code anywhere.  So I pressed on Alt + F11 to go back to my worksheet and nothing happened.  I did this 4 times and nothing happened.   Then I noticed that all of a sudden I had 4 Chart pages that were created when I pressed Alt + F11 the 4 times.  But I can't delete these pages.  

Please someone help me figure out:
1) How to delete these 4 Chart worksheets
2) Tell me what is wrong with my Mail Merge data sheet and how to fix it

Thanks so very much for your help!!!

Answer
Discuss

Answers

0

It is not easy to reply to video comments, so you did the right thing to come here)

Nothing you have said tells me that there is a macro in your workbook. It sounds like maybe someone protected the worksheet where you want to input the data. 

Go to the Review tab > and look to the Protect section and  if there is a button that says "Unprotect Sheet" then click that and remove protection and see if it works now.

To get to the code section for a worksheet, just right-click the worksheet tab and go to View Code. 

If you presst Alt + F11 to see the VBA, you can get to the code for the worksheet by opening the Project Explorer (Ctrl + R), usually a window pane on the left side of the window, expland the Microsoft Excel Objects folder for your project/file and double-click the desired worksheet to see any code specific to it.

If you have chart sheets, delete them like any regular tab - go to the worksheet interface, normal Excel, not the code window, and right-click the tab and click Delete.

Discuss
0

Hi cricket,

I found the following - give it a try.

("Selected cell highlighting, GONE!") - check out the info at these links:

teachexcel forum

and more info at:

teachexcel forum

It seems it has to do with your chosen colour scheme.

You could also check your settings in Excel:  open an Excel file, then click the Windows logo at top left, then click Excel Options bottom right, select Advanced and make sure "Enable fill handle and cell drag-and-drop" is checked.

Another possible solution I found is to close the Excel file then rename it with the same name just add (.xls) at the end of the name and then try.

Hope this helps.

Cheers   ;-}

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login