Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

Design Of One Way Slab Using Excel Sheet

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I have an excel sheet for designing of two way slab but that sheet is password protected. I had downloaded that sheet from internet so even I dont know the password of it. If anybody can crack its password.
Second thing is that I want a similar sheet for designing of one way slab. I know that this sheet is made using macro but I have no idea of using macro. If anyone can help me using macro. I also request if someone can make similar sheet for designing of one way slab. I want the designing to be be done using IS 456-2000 code and not ACI code.

View Answers     

Similar Excel Tutorials

Get a Table Look with Only the Formatting in Excel
How to get the nice formatting of a table without turning your data into an actual table. Formatting data as a tab ...
Activate or Navigate to a Worksheet using Macros VBA in Excel
Make a particular worksheet visible using a macro in Excel. This is called activating a worksheet and is rather eas ...
Print Comments in Excel
How to print the comments in a worksheet when you print from Excel. This includes how to print the comments within ...
Prevent a User from Changing Any Data in Excel
I'll show you how to lock a spreadsheet so that nothing can be changed in it. This is a great feature to use when ...

Helpful Excel Macros

Protect and Unprotect All Worksheets at Once
- This will allow you to protect or unprotct all worksheets in a workbook at once. It doesn't allow you to input a passwor
Hide Formulas in a Worksheet and Prevent Deletion
- This macro will hide all formulas within a workbook and not allow them to be deleted. The page will not be protected li
Name Worksheets Based on Cell Contents
- This macro allows you to have your worksheets named by whatever is in a particular cell within a worksheet. This means
Delete Entire Rows Based on Predefined Criteria (Text)
- This macro will allow you to specify certain criteria and then to delete rows based upon that criteria. You will choose
Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a

Similar Topics

I have an excel sheet which I got from some where but now I don't know where I got it from. In this sheet there is design of TWO WAY SLAB. I want similar sheet for designing of one way slab. There is macro in this sheet. This sheet works excellent. I am structural design Engineer.
I want to learn use of MACRO as it is very helpful in working with excel. I have to constantly make design sheets for various calculations. If anybody can help me work with it. Please provide me the kind of sheet for design of one way slab as I have attached.
Thank you.

Hello All,

In excel i have data as per below format

Emp ID Name CheckIn Checkout hrs/Duration SLAB
aaa 10:16 AM 7:36 PM 9:20
bbb 11:21 AM 8:37 PM 9:16

i want to calculate slab through formula.

Slab details
7-8 hrs should be in slab - A
8-9 hrs should be in slab - B
9-10 hrs should be in slab - C
10-11 hrs should be in slab - D


Would it be possible to make macro in Excel, to utilize granite slabs.
I work at the project, and usually I got slab which is different size. I recieve the sizes of the granite worktops, and I need to draw the drawing and fit in that way the worktops one the slab to reach the best usage of the slab.
Another words I need to do the best utilization of the slab. sometimes i need to use 2 or 3 or more. The point is to use as small as possible.
Is it possible to do such a thing in excel, or do you think differet program will be better ?


Hi All,

I need a formula to calculate values from slab Ranges.

for e.g

columnA columnB
1-10 A
11-20 B
21-30 C
31-40 D
41-50 E
51-60 F
61-70 G
71-80 H
81-90 I
91-100 J
101-110 K
111-120 L

If suppose value in cell c1 is 15, answer would be 'B' in cell D1 becuase it falls in 11-20 slab in A2.

I am using IF condition but it is not working for more than 7 times. Is there any other way to do this!

Thanks in advance!


I have developed a work book where in there are two sheets A & B. sheet B is linked with Sheet A i.e. values of sheet B are updated based on any change in sheet A and this is being done by a Sheet Activation Macro defined for Sheet B and every thing works perfectly.

Now I have protected my MACRO (VBA code) by applying password. and I protected Sheet B as well through password. But after protecting the sheet B, MACRO is not working on activation.

Can anyone guide me to fix this problem.

I want to apply slab rates to a figure.
For Example I have got a Number 400
Now want to apply slab rates like this

First 100 at 4.5/=
Next 200 hundreds (from 101 to 300) at 5/=
More than 300 at 6/=
please help creating formula
best regards

I want to protect a sheet with a password (which I know how to do), then when a macro is called I want the sheet unprotected at the start of the macro, then reprotected at the end of the macro. When I run my macro, a message box appears and asks me to enter the password to unprotect the sheet.

What I want is to NOT have to enter the password, but still have the sheet password protected. So I sort of want the macro to know my password and enter it for me, if that makes sense. Basically, I don't want other people editing certain cells, unless they run the macro, and to stop them getting around this, I don't want them to be able to unprotect the sheet without entering a password.

Heres the example code:

Please Login or Register  to view this content.

I have a sheet with following data

Row 2:
Level, Slab Area, status, casting date.
P2 , 212 , casted , 2-5-11
P3 . 486 ,
P2 ,500 , casted , 2-5-11
P2 , 100 , casted , 5-1-11
P1 , 200 , casted , 9-2-11
GF , 400 , casted , 7-3-11

I need the above table to reflect the most recent casted date for a particular slab and its area information infront of it. Further if there are two or more slabs casted in that particular date it should be able to add those.

Level, slab area , latest casting date
P3 , formula??? , formula??
P2 , formula??? , formula??
P1 , formula??? , formula??
GF , formula??? , formula??

I don't know if i have make my question clear, any help will be highly appriciated and thanks in advance.

Dear All,

I have a typical problem. actually we need to calculate tax on a total income where the tax rate would change depending upon the tax slab in which the total taxable income falls. Tax would be calculated on the basis of following

Slab No. Range Tax rate
1 $0-$500 0%
2 $500-$1000 10%
3 $1000-$1500 15% plus $50
4 $1500-$2000 20% plus $125
5 >$2000 30% plus $225

Now the problem is that either I write a very lengthy "if" formula (which we have to rewrite if the tax slab changes). also this is not a one tme excercise, since tax has to be calculated in the same worksheet at 4-5 places and the taxable income would also change if other components are changed. Can you please suggest some way out???

Thanks in advance.


I have Excel sheet which does some tidious calculation.
So cells have formula's.
i dont want any one else to see the formula when i share this document.
Is it possible to make Formula Bar password protected so that by only entring the password one can see the formula....

Similary need to know if Name of the macro list can be password
i have number of VB Macros for excel sheet and pressing ALT-F8 displays the macro..i want this to be hidden or password protected...

Your help will greatly be aprreciated...

Thank You in advance

Riz Momin

Ok, im rather new to macros, but here is my delimah.

I have a sheet that is protected, only certain cells are editable by users without the password. i wanted to create a macro that will hide certain field ranges. (that part i got done) here is the catch, when i Unlock the sheet with the macro, perform the actions, relock the sheet and close the macro, it all saves, but when i run the macro it 1. asks me for a password to unlock the sheet. i need this password to be hard coded into the macro so that everyone does not know it. and 2. once the macro has run, (it re protects the sheet like it was supposed to do, but i can unprotect the sheet without the use of a password. How can i fix those two things, and i hope i made some kind of sense explaining it

Hello Everyone. I am using Excel 2007 and I cannot get my table to allow filtering when my worksheet is password protected. I recorded a macro to unprotect the worksheet, sort the table, then protect the worksheet again. My problem is that when I protect the sheet again, I lose the ability to filter the table even though the macro includes the following code when it protects the sheet again.

ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowFiltering:=True

By trying different things I have found that if I password protect the sheet BEFORE the above code, filtering still works but the page is no longer password protected. It is simply protected (without a password). If I password protect the sheet after the above code, the sheet is password protected, but then I cannot filter the table.

Is there some way to allow filtering AND to have the sheet password protected?


I am designing a sheet, using it like a Form, there will be various inputs that VBA will pick up from set cells. Basically this will be used by different people, and it will execute SQL queries against an Oracle database (all that I already have working)...

There will be a cell for users Schema, and a cell that asks for the password.

When someone types in the password, I would prefer that it is masked, so maybe it can be replaced with ******** is this possible ?

Otherwise I was going to write the VBA to ask for the password...

I have attached a sample workbook which contains data and formula needed for the same.
Actually it is a problem based on slabs.

I have explained the requirement in the attachment itself.

If any further information required, please let me know.
1. Total no of month is fixed and is 144. Thus B1 or B2 will never exceed 144.

2. Since B1 = 18, thus till 18 months rate will 65 and from 19 onwsrds rate will be 75 till month 144. The logic is that 18 falls within 36 ie First slab. So Remining period of 126 months (Cell B2) will take next slab value.

3. Thus if B1 = 50 then it goes to Slab 2 for 72 months. Then in this case value for first 36 months will be 65, next (50-36) 14 months will be 75 and for Remoining period 94 months Amount will be 82.

4. Some examples calculated manually is given for ready reference.

Thanks and regards
Sujit Talukder

Hi every one,

I have a protected sheet and I use a macro to do some calculations. At the beginning of the macro I unprotect the sheet:


and it prompts me for the password. Fine so far. At the end of the code I protect the sheet:


The sheet apparently gets protected (I can't edit the cells, which is correct); however, I'm not prompted for the password to protect and if I go to the menu Tools-Protection-Unprotect Sheet... the sheet gets unprotected without asking me for the password. Could any one point out what I'm missing to get the sheet really protected and ask for the password every time I try to unprotect or protec it?

Note: the Workbook is also protected and I do not unprotect it at any time.

I have a workbook which is "Structure" protected (via Tool-Protect Workbook) which I forgot the password. I need to add a new sheet but it doesn't let me do it. I tried to save it as a new workbook (via Save As) with a different name but it did not change anything (same password protected). Of course I can create a new workbook from scratch but I need to avoid a lot of work and time I have spent in designing it.

Is there a way of duplicating (copying) the workbook to a new workbook, while keeping all shets and formulas the same without this protection?



My speadsheet is password protected but I need users to be able to run a macro (from a button) which creates a problem because of the password.

Using Activate.Unprotect I can bring up the password box and at the end Activate.Protect exept that this simply protects the sheet without a password.

I need the macro that they run to unprotect the sheet, perform it's functions and then reprotect the sheet with the same password.

Does anyone have any ideas, please?

Thanks guys


I have this code which allows me to Hide the formulas but i have a macro that needs to be run but this wont allow me to run the macro if the sheet is protected. What i wanted to do is have the sheet protected and password and formulas hidden the way it is but also have the option to enable me to run the macro without having to unhide the sheet/unprotect password etc.

Another thing i would like to do is have some sheets hidden (Not all the sheets but the the ones i want to hide) but also have them password protected by VBA so that its not a case where users can right click and Unhide sheet tabs but need the password to unhide

I am new to VBA.

Your help is much appreciated

Sub LockDown()
Dim WS As Worksheet
For Each WS In ThisWorkbook. WorkSheets
WS.Cells.FormulaHidden = True
WS.Protect Contents:=True, Password:="terces", UserInterfaceOnly:=True
ThisWorkbook.Protect Password:="drowssap", structu =True.
End Sub

I have a password protected sheet and want users to be able to run a macro which resets the auto filter, and once the macro has run, the sheet to be protected again with the original password

I don't mind having the password in the code


I am creating a macro is supposed to password protect a worksheet and then hide it.

I recorded the macro including entering a password. When I went to test the macro, it protected the sheet without setting a password at all.

I dont care if I have to manually enter the password or if it uses the password that i put in the macro, but at this point it doesnt password protect at all.

Anyone have any thoughs on how to correct this?

I need to run a macro that first unprotects a password protected sheet, and
then reprotects it later, with a password. The user will not know the
password, and therefore the code needs to, itself, have it hardcoded in
there. I am not concerned about someone digging in the code and finding the
password, so assume that's not an issue.

Is this possible, and if so, what is the code?


Hey guys,
So I have a sheet with sensitive information on it that cannot be viewed by everyone at our company, however this sheet is also used to update alot of things within the company on a daily basis.
I currently have two excel spreadsheets, one with all the important data that is password protected and another that pulls data from this sheet that everyone can access and update. Whenever I open the sheet everyone can access it updates by pulling data from the password protected sheet. When you do this it asks for the password. Is there anyway to get around this (autogenerate the password?) We can't turn off the password and we also can't give it out (otherwise it's pointless).
Any suggestions?


I have a very sensitive work sheet that I want to protect with a password. I know I can make this very hidden. But for extra protection I would like to do the following: Upon opening a workbook, I want to have one sheet open that someone can use to unlock the sheet that is hidden, by entering the a password into a particular cell (say something like DF3424, this will add extra security to where someone would need to know the password and the correct cell to enter it). The password would also be the name of the very hidden sheet. Upon pushing enter in the correct cell, a macro would take the password in that cell, run a line of code that would try to open a very hidden sheet that is named the password. If there is no such sheet to be unhidden then the workbook would close, else it would open the protected sheet.

Is this something that is possible? Is there a better solution?

How to create a formula in Excel to calculate the transportation charges automatically if we input the distance and weight? The slab of distance and weight is given below.

I have a code in a sheet that refreshes a pivot table, but I have the sheet password protected. What do I put in the code to unlock the sheet with the password, refresh the data, and re-lock the sheet using that same passowrd? Thanks in advance.