A couple of questions for members to whom “excel” in Excel!

S

sampson32

Active Member
Joined
Jul 16, 2003
Messages
312
Office Version
  1. 2021
Platform
  1. Windows
A couple of questions for members to whom “excel” in Excel!

1) I know you can “name” a cell (name box left of formula bar) and this name remains with that cell anywhere it may be positioned
*the above mentioned for example only.

Question:
Quite often I have to go into my spreadsheet and add various products (rows) to the several categories. I unlock the entire spreadsheet make all of my alterations then relock the entire sheet. I then go through and unlock the few cells that need to remain unlocked.

Can a cell be “marked” in a way as to make it remain unlocked? So when I lock the entire spreadsheet, regardless, these “marked” cells remain unlocked.

2) Can anyone point me to a post dealing with “autosizing” – independent of resolution (so my application will look the same regardless of an employees screen resolution?)

*********************
On a lesser issue – just for my knowledge – when dealing with custom commandbars in VBA, when a commandbar is created and added to the Toolbar menu - unless it is deleted and recreated after any changes to the VB code – the changes made will not materialize, it lives on the code it was created with. My question: where is the information the toolbars use kept? Is this code kept internal after their creation?
*********************
Thank you,
Sam
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Sort by date Sort by votes
Re: A couple of questions for members to whom “excel” in Exc

Select the cells you want to remain unlocked then Format>Cells and choose the protection tab. Uncheck the locked check box

HTH
 
Upvote 0
Re: A couple of questions for members to whom “excel” in Exc

Hi, I dont consider myself in the excel..lent alumni, nut heres my thoughts...

1. Protecting Cells
By default, every cell has the lock on but it has no affect until protection is applied. If a cell is unlocked and protection exists it will allow the user to edit the cell. So just leave the cells unlocked (format-cells-protection tab).

2.Screen resolution
This is for an Excel alumni! Dont know sorry :(

3. Custom Commandbars
To me its just like where you create a macro then assign a buton to it. Because you have told Excel that a macro is assigned to the button, it will run the macro thats behind it when you click it. if you create a custom menu, then whatever function youve put to that option will happen. If you just created the menu with no function behind it it would just sit there and look pretty :) These custom bars can be permanent (changes will remain for all workbooks) or just appear for that particular workbook.
 
Upvote 0
Re: A couple of questions for members to whom “excel” in Exc

For # 2, you can use a Windows API call to determine the current video mode width x height and adjust zoom from there.

This is from John Walkenbach:

Code: 
32-bit API declaration
Declare Function GetSystemMetrics Lib "user32" _
  (ByVal nIndex As Long) As Long

Public Const SM_CXSCREEN = 0
Public Const SM_CYSCREEN = 1

Sub DisplayVideoInfo()
    vidWidth = GetSystemMetrics(SM_CXSCREEN)
    vidHeight = GetSystemMetrics(SM_CYSCREEN)
    
    Msg = "The current video mode is: "
    Msg = Msg & vidWidth & " X " & vidHeight
    MsgBox Msg
End Sub

Hope that helps,

Smitty
 
Upvote 0
Re: A couple of questions for members to whom “excel” in Exc

I have a feeling Ivan can help, you with the resolution issue (PM link included)
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question
Redefine my macro
Replies
1
Views
340
chobanne
C
F
  • Question
Auto Populate Multiple Fields Based On Source Cell Data/Change
Replies
1
Views
631
FreshHits
F
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
395
AndyEd
A
A
  • Solved
Calendar issue
Replies
1
Views
1K
AndyEd
A
X
  • Question
Approach for evaluating a range with multiple conditions
Replies
0
Views
1K
XDee
X

Forum statistics

Threads
1,214,875
Messages
6,122,046
Members
449,063
Latest member
ak94

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top